﻿CREATE PROCEDURE [uspDrawerInsert]
     @drawerName nvarchar(80),
	 @tel nvarchar(80),
	 @address nvarchar(380),
	 @drawerID int OutPut

as
begin

	Insert 
	Into [Drawer]
		(
			[drawerName],[tel],[address]
		)
	Values
		(
			@drawerName,@tel,@address
		)

	Set @drawerID = (SELECT Ident_Current('Drawer'))

end